UCAS Field Mappings

The following tables describe how the UCAS column details are mapped onto ebs Tables/Columns:

Note: Where more than one field is listed, it is the first one in the list that is populated, unless otherwise stated.

UCAS Applicant Details (UCAS_APPLICANT_DETAILS)
UCAS Column ebs Table/Column Notes

Surname

People.surname  
DateofBirth People.date_of_birth Set to blank if outside institution defined boundaries
Firstname People.forename and People.middle_names Updated in 4.44 to split into forename and middle names
Title People.title Verifier lookup on Title
Gender People.sex Verifier Lookup on Sex
NationalInsuranceNumber People.ni_number  
MobilePhoneNo People.mobile_phone_number  
NominatedName People.fes_next_of_kin  
NominatedRelationship People.fes_nok_cont_rel  
DateEnteredUk People.date_uk_entry Added in 4.45
EmailAddress People.personal_email  
countryOfBirthCode People.place_of_birth Verifier code lookup on Nationality
preferredFirstname People.known_as or People.preferred_first_name Added in 4.45
uniqueLearnerNumber People.unique_learn_no  
personalID People_ilr.ucasperid  
nationalityCode People.Nationality Verifier code lookup on Nationality (added in 4.44)
  Addresses.addess_type Institution setting – “UCAS HE ebs Address Type”
  Addresses.start_date Import Date
  Addresses.owner_type Hard coded to “P”
Address1 Addresses.address_line_1  
Address2 Addresses.address_line_2  
Address3 Addresses.address_line_3  
Address4 Addresses.address_line_4  
Postcode Addresses.uk_post_code_pt1 and a.uk_postcode_pt2  
UCAS Applicant Qualifications (UCAS_APPLICANT_QUALIFICATIONS)
UCAS Column ebs Table/Column Notes
  Attainments.atype_attainment_type_code Institution setting – “UCAS HE Qualification on Entry code”
subjectOrCourse Attainments.description Attainment description is “levelcode – subjectOrCourse”
levelCode Attainments.description
entrydateyear Attainments.fes_year_achieved If resultorclass is populated. Defaults to current year if not set
resultOrClass Attainments.grade  
predictedGrades Attainments.fes_predicted_grade  
UCAS Applicant Choices (UCAS_APPLICANT_CHOICES)
UCAS Column ebs Table/Columns Notes
  People_units.unit_type Hardcoded to “A”
  People_units.progress_code Institution setting -“Default application progress code”
  People_units.progress_date Import date
  People_units.who_to_pay Institution setting, Applications “Who to pay”
  People_units.record_date Import date
courseCode   Used to find matching ebs UIO. PointOfEntry Included in matching from 4.46.
yearOfEntry  
pointOfEntry  
campus   Optionally used for course matching based on institution setting and reference data
UCAS Applicant Background (UCAS_APPLICANT_BACKGROUND)
UCAS Column ebs Table/Columns Notes
ethnicCode People.Ethnicity Verifier code lookup on Ethnicity (added in 4.44).